syDNCUpdateHistory

EntityType | Independent
Logical Entity Name | syDNCUpdateHistory
Default Table Name | syDNCUpdateHistory
Logical Only | NO
Owner | dbo
Definition |
Note |

syDNCUpdateHistory Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
BatchID |  | INTEGER | NO |
DNCUpdateGUID |  | UNIQUEID | YES |
OldLeadDate |  | DATETIME | YES |
NewLeadDate |  | DATETIME | YES |
BatchFirstStudent |  | INTEGER | YES |
BatchLastStudent |  | INTEGER | YES |
status |  | CHAR(1) | YES |
BatchStart |  | DATETIME | YES |
BatchEnd |  | DATETIME | YES |
StudentsUpdated |  | INTEGER | YES |

syDNCUpdateHistory Keys

Key Name | Key Type | Keys
IX_syDNCUpdateHistory_GUID_Old_New_LeadDate | Inversion Entry | DNCUpdateGUID, OldLeadDate, NewLeadDate
CIX_syDNCUpdateHistory | PrimaryKey | BatchID

syDNCUpdateHistory Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

syDNCUpdateHistory Check Constraints

Check Constraint Name | CheckConstraint

syDNCUpdateHistory Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.syDNCUpdateHistory | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

syDNCUpdateHistory Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model

syDNCUpdateHistory Data Movement Rules

Name | Type | Rule Text/Value